﻿

if not Exists(select * from sysobjects where name = 'NewsLetterEmailListSource' and Xtype = 'U') 
Begin

	Create table dbo.NewsLetterEmailListSource (
		Id int identity(1,1) not null,
		Name varchar(50) not null,
		TypeId varchar(50) not null,
		Settings varchar(max) null
	)

	alter table dbo.NewsLetterEmailListSource add constraint PK_NewsLetterEmailListSource_Id primary key (Id)

End